<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
<title>json拆分</title>
<style type="text/css">
* {
	margin: 0;
	padding: 0;
}

.container {
	padding: 10px;
}

.clear {
	clear: both;
}
</style>

</head>
<body>
	<div class="container">
		<div>
			源表名:
			<input type="text" id="fromTable" style="width: 300px;height: 20px;" placeholder="例: schema.table">
			
			json字段:
			<input type="text" id="jsonColumn" style="width: 300px;height: 20px;" placeholder="">
			
			临时表:
			<input type="text" id="tmpTable"  style="width: 300px;height: 20px;" placeholder="例: schema.table">
			
			目标表:
			<input type="text" id="toTable"  style="width: 300px;height: 20px;" placeholder="例: schema.table">
		</div>

		<div style="margin-top: 10px;">
			<!--
			json类型
			<select id="type"  style="width: 100px;height: 23px;">
				<option value="0">json对象</option>
				<option value="1">json数组</option>
			</select> 
			  -->
			  
			json拆分字段:<br>
			<textarea id="jsonAnalysis" style="width: 100%;height: 100px;margin-top: 5px;" placeholder="回车隔开"></textarea>
		</div>
		
		<div style="margin-top: 10px;">
			<button type="button" onclick="build()" style="width: 100px;">生成sql</button>
		</div>
		
		<div style="margin-top: 10px;">
			<textarea id="sqlDel" style="width: 100%;height: 20px;background-color: #efefef;"></textarea>
		</div>
		
		<div style="margin-top: 10px;">
			<textarea id="sqlCreate" style="width: 100%;height: 250px;background-color: #efefef;"></textarea>
		</div>
		
		<div style="margin-top: 10px;">
			<textarea id="sql" style="width: 100%;height: 250px;background-color: #efefef;"></textarea>
		</div>
		
		<div style="margin-top: 10px;">
			<textarea id="sqlInsert" style="width: 100%;height: 250px;background-color: #efefef;"></textarea>
		</div>
	</div>

	<script type="text/javascript" src="../jquery-3.4.1.min.js"></script>
	<script type="text/javascript" src="../jsonAnalysis/index.js?v=${jsrandom}"></script>
</body>
</html>
